/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mycompany.oj.Mapper;

import java.util.List;
import java.util.Map;

/**
 *
 * @author wucy
 */
public interface QuestionJudgeMapper {
    //蓝桥题库初始化
    public List<Map<String, Object>> initQuestionMapper(String kind);
    //加载具体题目
    public List<Map<String, Object>> initOneQuestionMapper(String id);
    //获取account的主键
    public List<Map<String, Object>> getAccountId(String username);
    //添加到收藏夹
    public String[] favoriteMapper(int student_id, int question_id, int i);
    //代码运行结果
    public List<Map<String, Object>> resultMapper(String schoolid);
    //获取题目答案
    public List<Map<String, Object>> getQuestion(String id);
    //计算蓝桥杯题库某道题的通过率
    public List<Map<String, Object>> calculateAC(String id);
    //计算实验某道题的通过率
//    public List<Map<String, Object>> calculate_course_AC(String id);
    //获取学生完成各个实验的题数,要先获取student主键
    public List<Map<String, Object>> haveFinishedNumber(String username, String course_name);
     //获取实验总题数section_num是章节号,section_number是个数
    public List<Map<String, Object>> totalNumber(String course_name);
    //获取课程下的所有实验题目
    public List<Map<String, Object>> allQuestion(String course_name);
    //获取最后一次提交时间,要先获取student主键
    public List<Map<String, Object>> getLastTime(String username, String question_course_id);
    //获取章节信息
    public List<Map<String, Object>> getZhangjieInformation(String course_name);
     //获取章节数
    public List<Map<String, Object>> getZhangjieNumber(String course_name);
    //实验页面目前题目,先转化
    public List<Map<String, Object>> lastCourseAddressMapper(String username);
    //题库页面目前题目
    public List<Map<String, Object>> lastAddressMapper(String username);
    //获取题目所在实验和实验的截至日期
    public List<Map<String,Object>> getCoursenameEndData(String course_name);
    //获取id为1的题目的名字
    public List<Map<String,Object>> getFirstId();
    //获取实验1的截至日期
    public List<Map<String,Object>> getFirstCourse(String course_name);
}
